SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 298;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('298', 'Cash Crusaders Montclair Mall','Cash Crusades Stores (Pty)Ltd','Cash Crusaders Montclair Mall','Shop 30 & 31 Montclair Shopping Centre, 169 Wood Road, Montclair','0310232447','4270290184','2020/027120/07','montclairmgr@crusadersstores.co.za');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Montclair Mall',CompanyName = 'Cash Crusades Stores (Pty)Ltd', TradingAs = 'Cash Crusaders Montclair Mall', Address='Shop 30 & 31 Montclair Shopping Centre, 169 Wood Road, Montclair', ContactNo = '0310232447', VATRegNo = '4270290184',RegNo = '2020/027120/07', StoreEmailAddress = 'montclairmgr@crusadersstores.co.za' where Store_ID = 298;
 END


 SET IDENTITY_INSERT [dbo].[store] off